[dbo].[BAEOrderCategoryInsert]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@Title	varchar(64)	64
@Description	varchar(1024)	1024
@Active	bit	1
@Header	varchar(512)	512
@Footer	varchar(512)	512
@Image	varchar(1024)	1024
@SecurityKey	varchar(64)	64

SQL Script

create procedure [dbo].[BAEOrderCategoryInsert] @Title as
varchar(64),
    @Description AS varchar(1024),
    @Active AS bit,
    @Header AS varchar(512),
    @Footer AS varchar(512),
    @Image AS varchar(1024),
    @SecurityKey AS varchar(64)
AS
    INSERT INTO OrderCategory
    (
    Title,
    Description,
    Active,
    Header,
    Footer,
    Image,
    SecurityKey
    )
    VALUES
    (
    @Title,
    @Description,
    @Active,
    @Header,
    @Footer,
    @Image,
    @SecurityKey
    );

    SELECT CAST(@@IDENTITY AS int) AS 'InsertedOrderCategory';

GO